MacWorld 1998 January

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1998 January / Macworld (1998-01).dmg / FileMaker Pro 4 / FM4 Templates w⁄data / Business / Inventory System / Product Inventory (.txt) next >

Wrap

FileMaker Pro Database | 1997-09-14 | 178KB | 1,156 lines

HBAM2016AUG95 Pro 3.0 HBAM3016AUG95@ bc132 gt139 oc102 ogb102 oghb101 ogsg105 ogt113 person tentH binoculars bootsF brookingsB brookings coast posterB coastA deerD posterD ghostC ghost posterC hikingF men'sF men's hiking bootsF oregonA oregon coast posterA personH posterA sunglasses tentH townC coastalA coastal postersA gearE gearE postersA HP DeskJet 540 Printer Pro 2.0 - 2.1F! Pro 3.0 CATEGORY CREATED BY DATE CREATED DATE MODIFIED INITIAL INVENTORY LEVEL OPEN TO BUY PEAK LEVEL PICTURE PRODUCT DESCRIPTION PRODUCT ID PRODUCT NAME QUANTITY ON HAND QUANTITY SOLD REORDER LEVEL REORDER QUANTITY RETAIL SUPPLIER ADDRESS SUPPLIER CITY SUPPLIER COMPANY SUPPLIER COUNTRY SUPPLIER FAX SUPPLIER ID SUPPLIER NAME SUPPLIER PHONE SUPPLIER STATE SUPPLIER ZIP CODE UNIT WEIGHT Product IDB Date CreatedB Date ModifiedB Product NameB Product DescriptionB Category search for all records whose Reorder Quantity is greater than zero, and then print a purchase order for each of those records. Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 7/29/975 Description Use this database file to track product inventory. How to use this solution Set the Initial Inventory Level--the quantity you have in stock. FileMaker Pro will automatically calculate Quantity On Hand by subtracting quantities sold in the Product Sales file.You can also set the Reorder Level, the minimum inventory you want to maintain, and the Peak Level, the maximum inventory you want to maintain. FileMaker Pro automatically calculates the Open to Buy, the difference betwee n the Quantity On Hand and the Peak Level. How to customize this solution You can create lookups in this file to your own supplier file. You can create a report and a script that will automatically generate purchase orders for products whose inventory level (Quantity On Hand) falls below the Reorder Level. FileMaker Pro calculates the Reorder Quantity as the difference between the Reorder Level and the Quantity On Hand. The script you create should search for all records whose Reorder Qu CostB RetailB PictureB InfoB Created ByB Quantity On HandB Reorder LevelB 50XgThe Reorder Level must be less than the Peak Level. Enter the minimum stock level you want to maintain. Z > 0) Initial Inventory LevelB X?The Initial Inventory Level must be greater than or equal to 0. [ >= 0) Quantity SoldB Supplier IDB Supplier NameB Supplier AddressB Supplier CityB Supplier StateB Supplier ZIP CodeB Supplier CountryB Peak LevelB 100XwThe Peak Level must be greater than the Reorder Level. Enter the quantity at which you want to maintain your inventory. Open to BuyB Unit WeightB Supplier PhoneB Supplier FaxB Supplier CompanyB Reorder QuantityB Form View - Product A List View Product Inventory Information Report Menu Form View - Supplier Form View - ProductB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Category Product ID Enter data for Products Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button Product Inventory Sales File... Initial Level Line Items File... Supplier Category Product ID Enter data for Products Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button Product Inventory Sales File... Initial Level Line Items File... Supplier Product Quantity Sold On Hand Reorder Level Peak Level Open to Buy Inventory Pricing Retail Description Unit Weight Picture Product InventoryB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter On Handc Retaild Coste Categoryf Nameg IDh+Click to see more information for a Products Infot Closeu View As Formv View As Listw Reportsx Recordy Delete Recordz Record{ Your Own Button| Your Own Button InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Product Inventory Close Product Inventory Close View As View As Reports Your Own Button Product ID Product Name On Hand Reorder Level Peak Level $Product Inventory Report by Category Page ## Open to Buy Report MenuB P0Information about the Product Inventory solutionQ Info for this SolutionS InfoT CloseU View As FormV View As ListW ReportsX Your Own Button View As FormV View As ListW ReportsX Your Own Button Your Own ReportI Your Own ReportJ Your Own ReportK Product InventoryL>Click on any of these buttons to preview the respective reportM Select a reportN InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button on any of these buttons to preview the respective reportM Select a reportN InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button Form View - SupplierB Yesfter Noarter Yesfter Noarter Yesfter Noarter InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Product ID v Enter data for Product Suppliers Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button Product Inventory Sales File... Line Items File... Supplier Product Company Address City / State / ZIP Code Country duct Suppliers Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button Product Inventory Sales File... Line Items File... Supplier Product Company Address City / State / ZIP Code Country Phone OC102Y 10/5/95 Oregon Coast Poster H8Oregon coast photograph by Ian Johnson. Limited edition. Coastal Posters 12.50 Fred Yvanovich 760 Ardwell St. Sacramento 94203 916-555-9400 916-555-9388 Principal Graphics BC132Y 10/5/95 Brookings Coast Poster H7Brookings Coast Poster by Ian Johnson. Limited edition. Coastal Posters Fred Yvanovich 760 Ardwell St. Sacramento 94203 916-555-9400 916-555-9388 Principal Graphics GT139Y 10/5/95 Ghost Town Poster HBGhost town in winter. Limited edition photography by Lori Mathews. Nature Posters 22.00 48.00 Fred Yvanovich 760 Ardwell St. Sacramento 94203 916-555-9400 916-555-9388 Principal Graphics D104Y 10/5/95 Deer Poster HQDeer peeking out behind a tree trunk. Limited edition photograph by Ian Johnson. Nature Posters InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button Open Product Sales File Open Product Line Items File Dial Phone wwwwww Helvetica Geneva Times Times New Roman Arial MS Sans Serif Fixedsys wwwwww ffffff UUUUUU DDDDDD )=400 Cancel You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request.E) Open Product Sales File Open Product Line Items File Sort by Product ID Sort by Product Name Sort by Category Product Inventory Report Open Script Dial Phone Sort by Product ID Sort by Product Name Product Inventory Report Sort by Category Open Script """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw CNAME FPTHACHARDDISK:CONSULT:ClarisII:KenMahlr:inbox:95-10-04:Product Sales.fp3 NAMEA Product Sales.fp3 RPTHA Product Sales.fp3 SRPTA prod_sal.fp3 WSPCA-C:\CONSULT\ClarisII\KenMahlr\inbox\95-10-04\ HNAME FPTHAHHARDDISK:CONSULT:ClarisII:KenMahlr:inbox:95-10-04:Product Line Items.fp3 NAMEA Product Line Items.fp3 RPTHA Product Line Items.fp3 SRPTA prod_itm.fp3 WSPCA-C:\CONSULT\ClarisII\KenMahlr\inbox\95-10-04\ (LIST LISTA-Coastal Posters Nature Posters Outdoor Gear VDEFA( Category List FMRLA Product Line Items ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" UUUUUU wwwwww (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,* !$&(265389,#!$$ '275? " $$*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:< /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)! //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+,)+" &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!PQ 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%&' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGCA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9< 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,027CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 876=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*, 169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,*3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7) !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,M4%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww wwwwww ffffff UUUUUU DDDDDD 333333 wwwwww ffffff UUUUUU DDDDDD 333333 wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" "%UR UD33D #4EWp "4EVx #3EVg "4DUg #3EVg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww wwwwww ffffff UUUUUU DDDDDD B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"#C0 4""#C0 AD@D@ AD@D@ AD@BL 44444 CCCCC 44444 CCCCC $42" @@BA@ bRBBP0 ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 333333 wwwwww UUUUUU DDDDDD """""" Helvetica Geneva Times Times New Roman Arial MS Sans Serif Fixedsys WCWantity is greater than zero, and then print a purchase order for each of those records. nature@ Rp 1J ffffff ffff33 ff33ff ff3333 33ffff 33ff33 333333 wwwwww UUUUUU DDDDDD """""" Uz\Vzz zz\zz[z \yy\yy zz\yz y\z[zz\z\ \zz\zy\z yzyUz \yUzzVz[z\Uy\U\yy\yy y\zyz zz[yz[ zUzVz Uzy\y y\zzy \z\y\ z\zz\z[z zUzzUzy VzVz[yV z[zyV\ zzy\yy Vyz\z yzzyz U[z\z Vy\zzU\Vz\ y\zVy\zzy zyzzV z[[\Uyz Vyz\y y\z\z U\z\zy z\yVy\z[[zU z\z\y zz\zz\z y\zy\ z\yzU UyzUzz UzUy\Uz Uzy\yy [zz[Uzz \yV[V z\y\y y\\z[z \zy\z \yy\zz yz\zz[ U[zzUy <zz[zzyV\z[ z[zz[z [zzUV zyzyy z\zz\z zy\zU Vz\z\\yV zFVzzUz z[z\Uz zUzyV Vyyzyz zy\Uzy y\z\Vzz\z ++UUV zUzyy \yzy\ yzzyz zz[z\z UyzVz\VzU yz[z[ UVyy\zz 1OU1U Uz[Vz\ UzUyUyV zVUVUU yVz\z * $$*$$ yU*1O1U zU\y[ \y\U\V\UzUz 1OTUO V\UVU VzzV[\y *0+NO U*VU[ VVyVUVUUVU \U[zUUVUU UVUVU VVUVUU UVyUVyUO \zUzz UUON1N*N1UU*$$ VVUO+ N**+N+ *+O*+*1*+ +**0U+0$ +OU1NU *@+** **0** +U1OU+T U1U+*+%* ++1+OU +OO+0O1 zz\z[z\ $$*$* *+*++**+** 1UUzz yz[zzyz V\yU\y 1*UUVy zUzyz \Vz\V UzVUUV\ **1** zUUVVUV VU\yVUyU\VUUVU[\ N**0O1UU UOUUT UyzV[ OU++* V[VUV *UVU1N1* O1*O*+U 1T1U0U *TO0TNOO*T+N*U1N T11TOUUOU **$** 101N1 TTUTT 01U11*1 TNN0O* 1OUN1 0U\z\ *$*$* *"OO1OO0O1 +N1OO1N1*+ON1 NUOUUTUOy U1OONN ON01NUT U"TUNUUOU *$*$$* **O1+N +N0T+UUO1 *N1+*++0+*+ N0N1O1 *N1N1 *5+*+ *TOTU $*$*$$ * +*OO0U *1N+N0O0*O *1N0T1O *$**$**O* $**$*N $**$$*$* O0UOU 1*1+* 1*101**1*+*+** 0OTUU+ 0++1+1+ **+** VUUO*1Py U1U\UVU *++** U@yUyU Uz[yUU*+ 0O1+11 1O1N**NUU*U1O0U*UOU1UO1U1* *B+*U UO*UU U&yV\zU *1*OO 0U1OUU+T0 OU1O1**+ **+*+ N+0*O1** +**+U1O 1O++* *1UU+U0O0U1 *U**+** +UONT **$$*U UUN** U1OU+ 11U0UU+ V\UU11N\ *10+0UT *0OO*OU Fred Yvanovich 760 Ardwell St. Sacramento 94203 916-555-9400 916-555-9388 Principal Graphics OGB102Y 10/5/95 Binoculars These fabulous binoculars bring beauty and action up close, with a field of vision breathtaking in its breadth and acuity. Large knurled knob permits precise focus. Leather carrying case and strap included. Black only. Made in U.S.A. Outdoor Gear 418.5 Hamid Fahrak 9280 Hamilton Way ` Billerica 01821 508-555-9130 Clear View Optics OGHB101Y 11/8/95 Men's Hiking Boots These boots have rugged, waterproof one-piece leather uppers. Stability and support are augmented by full-length nylon insoles and shanks underfoot. Polyurethane mid soles cushion and protect your feet. Outdoor Gear 121.5 Gus Trevorton 400 Amabelia St. Garland 75042 214-555-6142 General Footwear OGSG105Y 10/5/95 Sunglasses d$Fff@' Rp 1J >nf|` f&&ff 3"3!2 d$Fff@' These sunglasses by Star Mountaineering provide the maximum protection against the sun's damaging ultraviolet rays. Black or Navy. Strap included. Outdoor Gear Hamid Fahrak 9280 Hamilton Way ` Billerica 01821 508-555-9130 Clear View Optics OGT113Y 10/5/95 6 Person Tent Mountain Trek nylon 6 person tent. Made of 100% Dacron nylon blend for durability and warmth. Hand sewn in U.S.A. Accessories imported. Outdoor Gear 668.25 Sheila Stapleton 615 Mill St. Chico 95926 916-474-3383 916-474-3125 Hi Camp Supply Co. >nf|` natureC nature postersC outdoorE outdoor gearE postersA HP DeskJet 540 Printer Pro 2.0 - 2.1F! Pro 3.0